Introduction

R allows you to create a report that has the beauty and readability of a word document combined with interactive graphs and the functionality of a excel filtered table or even a pivot table?

Introducing…

MarkdownIcon
MarkdownIcon

You can import images, either from the web or from a local directory - this one is from the web and it is massive!

R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

You may notice the nice floating contents page to the left. This is created in the YAML header at the very start of the document. YAML stands for YAML Ain’t Markup Language. It sets some global parameters and can do some cool stuff. You set the headings as per the next section and the document automatically picks up those with a single ‘#’.

So what can you do?

Markdown formatting

You can play with headers that get smaller

You can play with headers - and smaller

You can play with headers - and smaller

You can play with headers - and smallest

You can make a line make a line break

You can do all the normal italics and bold and superscript and strike-though

Things like block quotes look funky
especially if you put a few together
make sure you end your sentences with 2
spaces to start a new paragraph

Other things that are easy

  • lists
  • putting stuff in lists
    • putting stuff in sub lists
    • such as this
  • did I say lists?

You can also do numbered lists

  1. Like this
  2. Fine example of a list
    • and do sub lists in a numbered list
      1. and do sub sub lists
        A. and sub sub sub list

Write some stuff in the middle of your list

  1. and then go back to the list
  2. NOTE: the numbers in the list are not specified, they are dynamic and if you go and edit one out it will adjust them automatically

You can colour in a block to assist with highlighting an area.

  • This is my first conclusion
  • This is my second conclusion

You can add footnotes1

You can also do basic dynamic tables just in markdown - looks messy in the code, pretty in the markdown and thanks to the power of HTML, they re-size according to the screen, all of these tables and charts are mobile friendly.

Column heading one Second column heading
Stuff Column 2 stuff
Another row of stuff More column 2 stuff

You can align the stuff in these tables but they don’t work well with numbers

Right Left Default Centre
blurb right aligned blurb left aligned blurb default blurb in da centre
1234 56788 4545644 43535
34.2 3442.1 3421.1 4512.45

You can also play with HTML tags to change font to comic sans

Just because you can does not mean you should!

Tabsets

Tabsets are great for creating nice interactive documents and reducing the length of your document but still cramming in loads of extra data without your reader realising it.

If you look at the code you can see that you can add a little fade to give your report a little extra sparkle or you can leave it for extra zip. I am using a bit of fade sparkle for this example

Results by provider

Provider code RXQ

Blah blah blah super important commentary about the blue line going up.

Provider code RJ1

Oh my - the red line is going up, no one wants to see a red line going up. Must remember to RAG rate this later and add a sad smiley face, pretty sure there will be a lesson on how to do that later.

Provider code RYJ

-insert witty commentary here-

That is the basic text formatting stuff, but we want to do clever things and incorporate our data

Adding some data

We are going to use the NHR-R sample data set and use the AE attendances data. This has a date, a organisation code, a type, number for attendances, admissions and breaches.

You can include data within the markdown specifically within the text by doing a back tick r and entering a variable or formula (you can also format it into a nice readable number).

For example the total number of attendances from the data set is 8,295,237

The date of 2024-06-21 is when you pressed the knit button report.

You can also add ‘code chunks’, these are chunks of code that sit within your markdown document.

So here is a the base way to include some data you simple do triple back ticks to tell R studio that now you want to do some R stuff.

This will print the summary of the AE attendance data set in a not very pretty table

## # A tibble: 9 × 6
##   period     org_code type  attendances breaches admissions
##   <date>     <fct>    <fct>       <dbl>    <dbl>      <dbl>
## 1 2019-03-01 RF4      other       10289       90          0
## 2 2019-02-01 RF4      other        9643       87          0
## 3 2019-01-01 RF4      other       10424       77          0
## 4 2018-12-01 RF4      other        9460       95          0
## 5 2018-11-01 RF4      other        8264       30          0
## 6 2018-10-01 RF4      other        7900       14          0
## 7 2018-09-01 RF4      other        7604       39          0
## 8 2018-08-01 RF4      other        7184       73          0
## 9 2018-07-01 RF4      other        5072       10          0

Library - Kable

Basic but by no means pretty, we can use the kable package to make a prettier table, in just 2 lines of code you can produce this, which has better readability and a nice reading hover over.

period org_code type attendances breaches admissions
2019-03-01 RF4 other 10289 90 0
2019-02-01 RF4 other 9643 87 0
2019-01-01 RF4 other 10424 77 0
2018-12-01 RF4 other 9460 95 0
2018-11-01 RF4 other 8264 30 0
2018-10-01 RF4 other 7900 14 0
2018-09-01 RF4 other 7604 39 0
2018-08-01 RF4 other 7184 73 0
2018-07-01 RF4 other 5072 10 0

The kable package to make a prettier table, indent rows and colour it in and change formats, add sub headings and is quite simple to use.

period org_code type attendances breaches admissions
sub heading and indent first 3 rows
2019-03-01 RF4 other 10289 90 0
2019-02-01 RF4 other 9643 87 0
2019-01-01 RF4 other 10424 77 0
2018-12-01 RF4 other 9460 95 0
2018-11-01 RF4 other 8264 30 0
2018-10-01 RF4 other 7900 14 0
2018-09-01 RF4 other 7604 39 0
2018-08-01 RF4 other 7184 73 0
2018-07-01 RF4 other 5072 10 0

Library - gt & gtExtra

gt also produces some nice looking tables, and has options to easily add a range of graphs as sparklines.

Numbers admissions attendances
type attendances breaches
R1H
1 323997 68090 94719
2 9790 41 0
other 167912 1020 0
RF4
1 225149 58234 59346
2 8957 16 0
other 62052 533 0
RQM
1 216764 15297 47862
other 102040 977 0

Kable & GT are really good for a static and pretty, but what if you want something more interactive?

Library - DT (short for data table)

This is a DT datatable - has lovely filters on the periods and different columns. You can re order the data and show as much or as little as you like. The export buttons export what you have selected. There is also a search function for the data.

You can mess around with the defaults so that it shows a larger table.

DT Datatable is pretty good and quick, even the base default comes up with a pretty good table. It is very nice at presenting a flat table, but if you want calculations and totals , you have to hard code them into your table.

That is one format or if you want more summary type reports you can use reactable.

Library - Reactable

This is reactable, and it works a little more like a filtered and sub grouped table. It is a bit trickier to use, but seems to be able to all the stuff of data table and a bit more.

Reactable is really good at creating summaries and drill down datasets. It creates all the groupings of data itself and so you do not have to wrangle the data into groups before you make the table. You can also create high level aggregate functions on a group and have the ability to drill down to see the underlying data.

Reactable has many more functions than a DT datatable but as I said, is a little more tricky to use.

You can use it to do funky stuff like this, I see your spark lines excel and raise you spark box plots! (and conditional formatting)

(Want to be super impressed? Hover over the spark box)

Lets get plotting…

Of course we can add a plot, you can change the size, alignment and all of that stuff. You can wrap your text around a plot and potentially have plots side by size.

You need to switch to the code here for a little funky plotting short cut.

Library - ggplot2

Library - NHSRplotthedots (SPC charts)

If you want to break away from the basic “up is good, down is bad” you need SPC charts.

Interactive plots…

Library - plotly

  • You can click on the legend to add or remove line
  • You can click and drag an area to zoom in on
  • You can hover over line to see data points
  • You can export as an image

All is far more customisable within the plotly function, you can have multiple select-able data sets and all manner of other stuff.

Library - dygraphs

So how about we take the admissions data for the providers above and create a nice time series graph. This DY graph is nice for playing with time series as it allows you to zoom in on certain areas.

There is also a nice little box on the bottom left of the graph. This allows you to smooth your data with a rolling average on the fly. Really useful for things such as length of stay or things with lots of variability and trying to pull out an overall trend.

Other good functions for visualising data sets.

Library - Treemap

One is treemap, it is like a posh pie chart for looking at proportions of a variable.

Obviously R can do pie charts, but I whereas I am willing to show you how add animated gifs into your reports, even I would not sink that low.

This is a nice overview of a large amount of data, gets a bit messy when you have a lot of factors

Library - collapsibleTree

Another really cool thing to play with is a dendrogram which you can make with collapsibleTree.

This is really good at showing flow through pathways and systems. You can make them horizontal or vertical and play with all manner of bits on the nodes.

Click on the nodes and you can also zoom in and out and scroll around.

Library - Leaflet

Leaflet is a great mapping library and works with open street map so you don’t have to worry about google API tokens and the like. There are some fantastic things you can do with the google service which allows you to access travel times and route finding, however for simple mapping leaflet is great. You can do heatmaps and areas, draw lines across points and also add layers that you can select on and off.

This example has 3 teams that are set up as layers and you can turn each one on and off.

The maps can be scrolled and zoomed and the icons remain to scale.

Library - Wordcloud2

Wordcloud2 is the sequel to wordcloud, much like Evil Dead 2 to the original, it is a far superior product, it has some really nice easy to use features and can make all manner of different wordclouds types.

However before you get to a word cloud you need some data which is basically a list of words and their frequency. You can do this manually on your fingers or you can get R to do this for you. I definately recommend the latter.

To get to that you read in some data, strip out all the gubbins such as punctuation, remove all the ‘stop words’ such as ‘the’ and ‘and’ etc and then remove white space and there you have a bunch of words fit for a cloud.

This is an example that pulls the text from a popular childrens novel and creates a cloud. Hopefully you can guess the book from the cloud.

You can hover over the words in the cloud and it will tell you the word and give you the number of the frequency.

Library - Rpivottable

Rpivottable has click and drag functionality. You can click through, create charts and heat maps, filter your data, calculate a pivot table with a median and just do all sorts of magic.

You can click and drag the variables around. You can click on the arrows to the side of the variables to filter them. You can click on the count to select a different metric and finally you can click on the table to change the results to a graph or heatmap or loads of things.

So what’s next?

Please feel free to hack and steal share best practice from this report.

This QR code links to this html file (https://lynhuk.github.io/presentations/R_demo.html): QR code and you can find the code that created it here: (https://github.com/LynHUK/presentations)

Join the NHS-R Community Take some training or sign up for a workshop The NHS-R community YouTube channel has a Getting Started playlist.

LinkedIn QR code
LinkedIn QR code

  1. This is the footnote from the footnote added way way up above↩︎